I had the same problem. I used to be able to open files with the .SQL extension into a single instance of SQL Server management studio. My previous hard-drive failed, and when I reloaded the new one, I must have changed the order in which I installed Visual Studio and MSSQL, because VS became the new default application for SQL files. I tried changing the file association to SQLWB.exe, but that gave me the multiple instance problem. Hitting "Default" only changed the file association back to VS. After a little trial and error, I believe I have the solution:
Delete the existing file type association for SQL.
Click “New” and enter SQL for the File Extension, then click “OK.”
The new file association should show at the top of your list, and the details should show in the frame below.
Click on “Advanced”.
To change the icon, click on the “Change Icon” button and browse to "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe" (if SQL Server is located on a different drive, adjust the path accordingly.)
Select the icon of your choice, and click “OK”.
Click the “Edit” button, fill in the page with the values below, then click “OK”:
Application used…: "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe" /dde "%1"
Use DDE: Checked
DDE Message: Open("%1")
Application: sqlwb.9.0
Topic: system
Click “OK” to save the changes, and “Close” to exit “Folder Options.”
-
Edited by
BAInnes
Monday, February 08, 2010 9:17 PM
Missing command-line parameter